2017-07-20 - 48130 - Enhancement - ICD100 Report Enhancement #CrystalReportsSupport
ENHANCEMENT
48130 - EMEA Requests - ICD100 Report Enhancement
Requirement Summary
Need to add new column with priority code of the sales order & issue fix in ICD100 report.
Admin Info
| Purpose |
Need to add new column with priority code of the sales order & issue fix in ICD100 report. |
| Requested By |
Saravanan Lakshmanan |
| Spec Created By |
Dhananjay G |
| Spec Created Date |
07/20/2017 |
| Spec QA by |
Uday Kumar P |
| Objects |
ICD100 EMEA Version |
| Document Status |
Complete |
Estimates
| SNo |
Activity |
Estimation in Hours |
| 1 |
Research |
00 |
| 2 |
Documentation |
01 |
| 3 |
Development/ Config |
16 |
| 4 |
Unit test in DEV |
03 |
| 5 |
Unit test in QUA |
00 |
| 6 |
Other activity |
00 |
| TOTAL |
20 |
References
Prior Tickets
NoneDocuments
ICD100 - Open PO Report by ICD.xlsSpec Changes
| SNo |
Change Details |
Requested By |
Requested On |
Notes if any |
Functional Requirement
Purpose/WHY:
This report provides visibility of the open purchase orders.In Scope:
EMEA Region.Out of Scope:
Other Regions.Solution Summary
1. Need to add Priority code of the sales order in a new column.
2. Need to validate the report with SAP ECC tables.
3. Need to promote the report into BI Production after successful validation.
4. Need to fix the join issues in the table.
Test Plan
| SNo. |
Test Scenario |
Expected Results |
| 1. |
Report Format. |
As per NEC standards. |
| 2. |
Execute Crystal Report in Crystal Designer tool after changes. |
Report should execute successfully in Crystal Designer tool. |
| 3. |
Schedule the Report in NEC BI Launch Pad. |
Report should execute successfully in NEC BI Launch Pad. |
Solution Details
1. Fixed the issue by using table links in report:
2. Added Priority code(VBAP.LPRIO) of the sales order in a new column.
3. Validated the report with SAP ECC tables.
4. Promoted the report into BI Production after successful validation.
Issues
None